/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.yunhoo.base.db.dao;

import com.yunhoo.base.model.Department;
import java.sql.SQLException;
import java.util.List;

/**
 *
 * @author Administrator
 */
public interface DepartmentDao {

    public void insert(Department dept) throws SQLException;

    public void update(Department dept) throws SQLException;

    public void updateIsEnd(Department dept) throws SQLException;

    public void delete(Department dept) throws SQLException;

    public void deleteById(Department dept) throws SQLException;

    public Department queryById(Department dept) throws SQLException;

    public List<Department> queryAll(Department dept) throws SQLException;

    public List<Department> directSubNodes(Department dept) throws SQLException;

    public Department nameRepeatForInsert(Department dept) throws SQLException;

    public Department nameRepeatForUpdate(Department dept) throws SQLException;

    public List<Department> queryListByOrgAndYear(Department dept) throws SQLException;
}
